*1 podrazdelenie

Zapros iz Zapasov -  tovar i kolvo po podrazdeleniju:
1- Ofis, 2- Sklad, 3-Kraslava

SELECT tovari.tovar as [Naimenovanie tovara], zapasi.kolic as [Kolichestvo]
FROM tovari, zapasi
WHERE zapasi.kod_podrazd="3"
AND tovari.kod_tovara=zapasi.kod_tovara
_______________________________________
*2 uslovie kases

zapros iz Tovarov - naimen tovara(tovar) i cena bez PVN
po usloviju "kases*" (sovpadenie po "kases", a daljshe ne vazhno - *)

select tovar, cena_bez_pvn
from tovari
where tovar like "kases*"
_______________________________________________
*3 autoPVN

zapros iz Tovarov  - cena bez PVN * 1.18 po formatu "### ##0.00 Ls"
(beret cenu bez pvn, schitaet  po zadannoj formule i vidaet cenu s pvn)

select tovar,
format (cena_bez_pvn*1.18,"### ##0.00 Ls") as [cena s pvn]
from tovari
where cena_bez_pvn 
_____________________________________________________
*4 alias psevdonim

Viborka bolee chem iz odnoj tablici
Zapros iz tovarov - tovar i cenu bez pvn
po psevdonimu tablici 'Tovari - t" 

select t.tovar as [naimenovanie tov], t.cena_bez_pvn as [zakupka]
from tovari t
____________________________________________________
*5  po kod tovara

Zapros iz Tovarov - tovar 
i  Zapasov - kolichestvo
 po obschemu dlja tablic polju - "kod_tovara"
(Vivod naimenovanija i kolichestva )

select tovari.tovar, zapasi.kolic
from tovari, zapasi
where tovari.kod_tovara=zapasi.kod_tovara
______________________________________________________
*6 Toljko SKLAD

Zapros iz Tovarov - tovar i Zapasov - kolichestvo, kod podrazd
po obschemu kodu tovara toljko dlja Sklada - 2


select t.tovar, z.kolic
from tovari t, zapasi z
where z.kod_podrazd="2"
and t.kod_tovara=z.kod_tovara
_____________________________________________________
*7 usl sklad_gr

Zapros iz Podrazdelenij - kod podrazdelenija, podrazdelenie
iz Tovarov - kod tovara, gruppa, tovar
iz Zapasov - kolichestvo.
(2 uslovija: "kod_podrazd", "gruppa" - ispoljzovatj odno/dva).

1-e usl.:  (Etot primer: Vivod kod podrazdelenija - 2,
           t.e  podrazdelenie - "SKLAD", prinadlezhaschie emu kodi tovarov,
           tovar, kolichestvo.)
2-e usl.:  (I toljko iz 2-oj gruppi, t.k. "gruppa=02").  

SELECT
p.kod_podrazd, p.podrazd, 
t.kod_tovara, t.gruppa, t.tovar,
z.kolic
FROM
tovari t INNER JOIN (podrazd p INNER JOIN zapasi z ON p.kod_podrazd = z.kod_podrazd) ON t.kod_tovara = z.kod_tovara
WHERE
(((p.kod_podrazd)="2") AND ((t.gruppa)="02"));
___________________________________________________________
*8 usl sklad_gr(2)+ceni

Modifikacija prediduschego zaprosa.
 iz Podrazdelenij - kod podrazdelenija, podrazdelenie
 iz Tovarov - kod tovara, gruppa, tovar, cena bez PVN/s PVN ( v formate: "### ##0.00 Ls")
 iz Zapasov - kolichestvo.
(Uslovija te zhe)

SELECT
      p.kod_podrazd as [Kod podrazdelenija],
      p.podrazd as [Podrazdelenie],
      t.kod_tovara as [Kod tovara],
      t.gruppa as [Gruppa],
      t.tovar as [Naimenovanie],
      format (t.cena_bez_pvn,"### ##0.00 Ls") as [Zakupka],
       format (t.cena_s_pvn,"### ##0.00 Ls") as [Prodazha],
      z.kolic as [Kolichestvo]
FROM
      tovari t INNER JOIN (podrazd p INNER JOIN zapasi z  ON p.kod_podrazd = z.kod_podrazd)
ON t.kod_tovara = z.kod_tovara
WHERE
      (((p.kod_podrazd)="1") AND ((t.gruppa)="01"));
_____________________________________________________________
Zapros dlja UO

Stats

SELECT 
st1.str, 
Format(str*1,"000") AS hits, 
st1.dex, 
Format([dex]*1,"000") AS stam, 
st1.int, 
Format([int]*1,"00") AS mana, 
Format([str]*4+30,"000") AS weight, 
st1.gold
FROM st1
WHERE (((st1.str)<>False) 
AND ((st1.dex)<>False) 
AND ((st1.int)<>False) 
AND ((Format([str]*4+30,"000"))<>False));


_______________________________________
UO

Zapros "Vremja udara"
Ves oruzhija
___________________________________
SELECT ves.vs AS [ves oruzhija],
Format([vs]/2.7,"0.0") AS [vremja udara]
FROM ves;
______________________________

Rass4et urona po formule:
________________________________

   : dam=(*8*k)/2,7    (     )  dam=(*8*k*1,10025)/2,7 , , dam=(*3,26*k)  . : 

(/2,7)  ,     

8*k   

k     

(  k=1,    5%) 
 ,           .  ,   8   ,    14,8 :)  

____________________________
uron_(1_ru4n)

sozdatj  Kf - Ore, koeficient po formule "Iron=1+0.5%^"
i ves oruzhija
(dam/vremja_1_udara=dam/sek)
*** dam ***

SELECT [vs] AS ves_oruz, [Ore] AS Ruda, [K] AS Koef, format([vs]*8*[K]/2.7,"### #0.0 ") AS Damage
FROM ves, kf
WHERE ves.id;

*** dam/sek ***

SELECT [vs] AS ves_oruz, [Ore] AS Ruda, [K] AS Koef, format(([vs]*8*[K]/2.7)/([vs]/2.7),"### #0.0 ") AS Damage
FROM ves, kf
WHERE ves.id;
_____________________________
uron1_(2_ru4n) ***dam***


SELECT vs AS ves_oruz, Ore AS Ruda, K AS Koef, 
format (vs*8*K*1.10025/2.7, "### #0.0 ") AS Damage
FROM ves, kf;

*** dam/sek

SELECT [vs] AS ves_oruz, [Ore] AS Ruda, [K] AS Koef, 
format ((vs*8*K*1.10025/2.7)/(vs/2.7), "### #0.0 ") AS [dam/sek]
FROM ves, kf
WHERE ves.id;    
________________________________
uron2_(2_ru4n)
(analogi4na "uron1_(2_ru4n)"
Upros4ennij variant. (dr. formula)
*** dam ***

SELECT vs AS ves_oruz, K AS Koef, 
format (vs*3.26*K, "### #0.0 ") AS DAM
FROM ves, kf;

*** dam/sek ***

SELECT [vs] AS ves_oruz, [Ore] AS Ruda, [K] AS Koef, 
format ((vs*3.26*K)/(vs/2.7), "### #0.0 ") AS [dam/sek]
FROM ves, kf
WHERE ves.id;
_____________________________________
Vremja 1-go udara


SELECT vs AS [ves_oruz], 
format (vs/2.7, "### #0.0 sek") AS[vremja_1-go_udara]
FROM ves
______________________________________
[uron_(1_ru4n_oruzh)].[Damage]/[vremja_1-go_udara].[vremja_1-go_udara]




select Damage, vremja_1-go_udara,
format (ur_1ruc/vr1ud, "### #0.00 dam ") as uron
from [uron_(1_ru4n_oruzh)], [vremja_1-go_udara]
________________________________________________

 *** !!! ***


total_dam (1 ruc) ili  (tdam_1ruc  - sovmes4aet v sebe vse)
(*ruc_dam-sek, uron*_(*_ru4n), vr1ud  - teperj ne trebujutsja) 

SELECT 
ves.vs AS ves_oruz, kf.Ore AS ruda, kf.K AS koef, 
Format([vs]/2.7,"0.0"" sek""") AS vr_1_udara, 
Format([vs]*8*[K]/2.7,"0.0 ") AS damage, 
Format(([vs]*8*[K]/2.7)/([vs]/2.7),"0.0") AS [dam/sek]
FROM ves, kf;
____________________________________________________
tdam1_2ruc


SELECT 
ves.vs AS ves_oruz, kf.Ore AS ruda, kf.K AS koef, 
Format([vs]/2.7,"0.0"" sek""") AS vr_1_udara, 
Format([vs]*8*[K]/2.7,"0.0 ") AS damage,
Format ((vs*8*K*1.10025/2.7)/(vs/2.7), "### #0.0 ") AS [dam/sek]
FROM ves, kf;
_____________________________________________________
tdam2_2ruc

SELECT 
ves.vs AS ves_oruz, kf.Ore AS ruda, kf.K AS koef, 
Format([vs]/2.7,"0.0"" sek""") AS vr_1_udara, 
Format([vs]*8*[K]/2.7,"0.0 ") AS damage, 
Format ((vs*3.26*K)/(vs/2.7), "### #0.0 ") AS [dam/sek]
FROM ves, kf;

==========================================================
Q-F2 (po tipu "Q-*", v dannom slu4ae - vivod koli4estva vseh F-Films)

SELECT Count(CD_Collection.CD_Name) AS Sum_F, CD_Collection.CD_Type
FROM CD_Collection
GROUP BY CD_Collection.CD_Type
HAVING (((CD_Collection.CD_Type)="F"));


_____________________________________________________
Sum_CD
(iz bazi CD_DB)

zapros summi dannih(zapolnennih polej) bazi po "CD_Type"
(F-Films, G-Games...)
1. Ispoljzovani zaprosi tipa -  "Q-*"  (prim: "Q-F")
2. Ispoljzovani zaprosi tipa -  "Q-*2" (prim: "Q-F2")
3. Ispoljzovana sama tablica s dannimi - "CD_Collection", dlja opredelenija
max. koli4estva zapisej v tablice po polju "CD_Name"
Zapros "Q-*" bil preobrazovan v "Q-*2",potom + max. kol-vo CD, zatem v "Sum_CD" 

SELECT [Q-F2].CountOfCD_Name AS sum_F, [Q-G2].CountOfCD_Name AS sum_G, [Q-M2].CountOfCD_Name AS sum_M, [Q-O2].CountOfCD_Name AS sum_O, [Q-P2].CountOfCD_Name AS sum_P, [Q-S2].CountOfCD_Name AS sum_S, [Q-X2].CountOfCD_Name AS sum_X, Count(CD_Collection.CD_Name) AS Total_CD
FROM [Q-F2], [Q-G2], [Q-M2], [Q-O2], [Q-P2], [Q-S2], [Q-X2], CD_Collection
GROUP BY [Q-F2].CountOfCD_Name, [Q-G2].CountOfCD_Name, [Q-M2].CountOfCD_Name, [Q-O2].CountOfCD_Name, [Q-P2].CountOfCD_Name, [Q-S2].CountOfCD_Name, [Q-X2].CountOfCD_Name
_______________________________________________________________________________

